<!DOCTYPE html>
<html lang="en">
<head>
<title>How do I format my file for importing grades into Gradebook?</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta content="" name="description">
<link href="../css/help.css" media="all" rel="stylesheet" type="text/css" charset="utf-8">
<link href="/library/webjars/fontawesome/4.7.0/css/font-awesome.min.css" media="screen" rel="stylesheet">
<link href="/library/skin/morpheus-default/tool.css" media="screen" rel="stylesheet" type="text/css" charset="utf-8">
<script src="/library/webjars/jquery/1.12.4/jquery.min.js" type="text/javascript" charset="utf-8"></script>
<script src="/library/js/headscripts.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript" charset="utf-8">
    includeWebjarLibrary('featherlight');
    $(document).ready(function(){
      $("a.screensteps-image-zoom").featherlight({
        type: { image:true },
        closeOnClick: 'anywhere'
      }); 
    });   
</script>
</head>
<body>
  <div><div>
<div><h1 class="article-title">How do I format my file for importing grades into Gradebook?</h1></div>
<div>



    <div class="step-instructions screensteps-textblock screensteps-wrapper--introduction screensteps-wrapper">
  <div id="text-content_ED87E34B-5A98-42DB-B722-C9A735F8FDF2" class="text-block-content">
    <p>Manage grades offline in a spreadsheet and then import the file to update the Gradebook. You can also import a file as a method for quickly creating several Gradebook items at once. </p>
<p>To obtain a file in the proper import format, <a href="content.hlp?docId=howdoiexportgradesfromgradebook">export your Gradebook</a> and use that file as a template. This will ensure that the file contains all of the student information in your site, as well as any existing Gradebook item information in your site.</p>
  </div>
</div>

      <div class="step screensteps-section screensteps-depth-1">
    <h2 class="step-title screensteps-heading">Go to Gradebook.</h2>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/006/984/406/original/a7b71d64-b22b-422a-a40d-2d8f90242f0a.png" alt="Image of Gradebook button." height="105" width="185">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_32BDE3E8-0BD5-4A73-9B58-5D8269D9E95B" class="text-block-content">
    <p>Select <strong>Gradebook</strong> from the Tool Menu of your site.</p>
  </div>
</div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1">
    <h2 class="step-title screensteps-heading">Click Import/Export.</h2>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/007/003/885/original/3e5fd60c-d312-4eb9-98f3-afb1a4d207e0.png" alt="" height="49" width="412">
  </div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1">
    <h2 class="step-title screensteps-heading">Click Export Gradebook.</h2>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/007/003/887/original/98824114-c72a-47f4-9052-f2139a4f74c7.png" alt="" height="139" width="621">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_5C5B1BBE-1870-4418-88D5-89B9586E04EF" class="text-block-content">
    <p>Click Export Gradebook to download a CSV file that you can later use for import.</p>
  </div>
</div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1" id="open-the-file-in-your-preferred-spreadsheet-application">
    <h2 class="step-title screensteps-heading">Open the template in your preferred spreadsheet application.</h2>
        <div class="image screensteps-image">
      <a href="https://media.screensteps.com/image_assets/assets/003/155/666/original/7c596e2d-93b5-47f1-b3ae-8088ec42aacc.png" class="screensteps-image-zoom">
        <img src="https://media.screensteps.com/image_assets/assets/003/155/666/medium/7c596e2d-93b5-47f1-b3ae-8088ec42aacc.png" alt="" height="360" width="855">
      </a>
  </div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1" id="add-columns-grades-and-or-feedback-as-needed-and-save-your-file">
    <h2 class="step-title screensteps-heading">Add columns, grades, and/or feedback as needed, and save.</h2>
        <div class="image screensteps-image">
      <a href="https://media.screensteps.com/image_assets/assets/003/155/672/original/14e33758-f2bb-461e-aeb7-0895ce68382a.png" class="screensteps-image-zoom">
        <img src="https://media.screensteps.com/image_assets/assets/003/155/672/medium/14e33758-f2bb-461e-aeb7-0895ce68382a.png" alt="" height="360" width="855">
      </a>
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_3A6FE3D4-2CE3-41A1-A647-94968BF7F2F0" class="text-block-content">
    <p>The import file must be in CSV file format. Also, be sure to use the following conventions:</p>
<ol>
<li>Student ID and Student Name are the first two columns and must be retained for any future imports.</li>
<li>Gradebook Items/Assignments can include points by wrapping the points in [ ] after the title (e.g., Assignment 1 [50]).</li>
<li>Comments can be imported by prefixing the column with a * (e.g., * Assignment 1).</li>
<li>Columns that cannot be re-imported are prefixed with #.</li>
</ol>
  </div>
</div>
 
      <div class="step-instructions screensteps-textblock screensteps-wrapper--tip screensteps-wrapper">
  <div id="text-content_2B115D6C-70F1-4EC7-935C-3C891BC4BC0F" class="text-block-content">
    <p><em><strong>Note</strong>: add new items to the Gradebook by including new columns in your file. If you add new columns without a point value in brackets, Gradebook will prompt you to indicate the number of points upon import.</em></p>
  </div>
</div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1" id="click-choose-file">
    <h2 class="step-title screensteps-heading">In Gradebook, click Choose File.</h2>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/007/003/889/original/e20a0034-4213-45bb-a87f-e76b239a759b.png" alt="" height="206" width="649">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_ADEC112E-C9F3-4866-A410-A48E864868A0" class="text-block-content">
    <ol>
<li>Click <strong>Choose File </strong>to browse for and select the import file from your device.</li>
<li>Click <strong>Continue</strong>.</li>
</ol>
<p>For more information on importing your items into Gradebook, see <a href="content.hlp?docId=howdoiimportgradesintogradebook">How do I import grades into Gradebook?</a></p>
  </div>
</div>
 
  </div>


</div>
</div></div>
</body>
</html>
